<template>
    <!-- 搜索 -->
    <ContentWrap>
        <el-form
                ref="queryFormRef"
                :inline="true"
                :model="queryParams"
                class="-mb-15px"
                label-width="68px"
        >
            <el-form-item label="表名称" prop="tableName">
                <el-input
                        v-model="queryParams.tableName"
                        class="!w-240px"
                        clearable
                        placeholder="请输入表名称"
                        @keyup.enter="handleQuery"
                />
            </el-form-item>
            <el-form-item label="表描述" prop="tableComment">
                <el-input
                        v-model="queryParams.tableComment"
                        class="!w-240px"
                        clearable
                        placeholder="请输入表描述"
                        @keyup.enter="handleQuery"
                />
            </el-form-item>
            <el-form-item label="创建时间" prop="createTime">
                <el-date-picker
                        v-model="queryParams.createTime"
                        unlink-panels
                        :default-time="[new Date('1 00:00:00'), new Date('1 23:59:59')]"
                        class="!w-240px"
                        end-placeholder="结束日期"
                        start-placeholder="开始日期"
                        type="daterange"
                        value-format="YYYY-MM-dd HH:mm:ss"
                />
            </el-form-item>
            <el-form-item>
                <el-button @click="handleQuery">
                    <Icon class="mr-5px" icon="ep:search"/>
                    搜索
                </el-button>
                <el-button @click="resetQuery">
                    <Icon class="mr-5px" icon="ep:refresh"/>
                    重置
                </el-button>
                <el-button v-hasPermi="['infra:codegen:create']" type="primary" @click="openImportTable()">
                    <Icon class="mr-5px" icon="ep:zoom-in"/>
                    导入
                </el-button>
            </el-form-item>
        </el-form>
    </ContentWrap>

    <!-- 列表 -->
    <ContentWrap>
        <el-table v-loading="loading" :data="list">
            <el-table-column align="center" label="数据源">
                <template #default="scope">
                    {{
                        dataSourceConfigList.find((config) => config.id === scope.row.dataSourceConfigId)?.name
                    }}
                </template>
            </el-table-column>
            <el-table-column align="center" label="表名称" prop="tableName" width="200"/>
            <el-table-column
                    :show-overflow-tooltip="true"
                    align="center"
                    label="表描述"
                    prop="tableComment"
                    width="200"
            />
            <el-table-column align="center" label="实体" prop="className" width="200"/>
            <el-table-column
                    :formatter="dateFormatter"
                    align="center"
                    label="创建时间"
                    prop="createTime"
                    width="180"
            />
            <el-table-column
                    :formatter="dateFormatter"
                    align="center"
                    label="更新时间"
                    prop="createTime"
                    width="180"
            />
            <el-table-column align="center" fixed="right" label="操作" width="300px">
                <template #default="scope">
                    <el-button
                            v-hasPermi="['infra:codegen:preview']"
                            link
                            type="primary"
                            @click="handlePreview(scope.row)"
                    >
                        预览
                    </el-button>
                    <el-button
                            v-hasPermi="['infra:codegen:update']"
                            link
                            type="primary"
                            @click="handleUpdate(scope.row.id)"
                    >
                        编辑
                    </el-button>
                    <el-button
                            v-hasPermi="['infra:codegen:delete']"
                            link
                            type="danger"
                            @click="handleDelete(scope.row.id)"
                    >
                        删除
                    </el-button>
                    <el-button
                            v-hasPermi="['infra:codegen:update']"
                            link
                            type="primary"
                            @click="handleSyncDB(scope.row)"
                    >
                        同步
                    </el-button>
                    <el-button
                            v-hasPermi="['infra:codegen:download']"
                            link
                            type="primary"
                            @click="handleGenTable(scope.row)"
                    >
                        生成代码
                    </el-button>
                </template>
            </el-table-column>
        </el-table>
        <!-- 分页 -->
        <Pagination
                v-model:limit="queryParams.pageSize"
                v-model:page="queryParams.pageNo"
                :total="total"
                @pagination="getList"
        />
    </ContentWrap>

    <!-- 弹窗：导入表 -->
    <ImportTable ref="importRef" @success="getList"/>
    <!-- 弹窗：预览代码 -->
    <PreviewCode ref="previewRef"/>
</template>
<script lang="ts" setup>
import {dateFormatter} from '@/utils/formatTime'
import download from '@/utils/download'
import * as CodegenApi from '@/api/infra/codegen'
import * as DataSourceConfigApi from '@/api/infra/dataSourceConfig'
import ImportTable from './ImportTable.vue'
import PreviewCode from './PreviewCode.vue'

defineOptions({name: 'InfraCodegen'})

const message = useMessage() // 消息弹窗
const {t} = useI18n() // 国际化
const {push} = useRouter() // 路由跳转

const loading = ref(true) // 列表的加载中
const total = ref(0) // 列表的总页数
const list = ref([]) // 列表的数据
const queryParams = reactive({
    pageNo: 1,
    pageSize: 10,
    tableName: undefined,
    tableComment: undefined,
    createTime: []
})
const queryFormRef = ref() // 搜索的表单
const dataSourceConfigList = ref<DataSourceConfigApi.DataSourceConfigVO[]>([]) // 数据源列表

/** 查询列表 */
const getList = async () => {
    loading.value = true
    try {
        const data = await CodegenApi.getCodegenTablePage(queryParams)
        list.value = data.list
        total.value = data.total
    } finally {
        loading.value = false
    }
}

/** 搜索按钮操作 */
const handleQuery = () => {
    queryParams.pageNo = 1
    getList()
}

/** 重置按钮操作 */
const resetQuery = () => {
    queryFormRef.value.resetFields()
    handleQuery()
}

/** 导入操作 */
const importRef = ref()
const openImportTable = () => {
    importRef.value.open()
}

/** 编辑操作 */
const handleUpdate = (id: number) => {
    push('/codegen/edit?id=' + id)
}

/** 预览操作 */
const previewRef = ref()
const handlePreview = (row: CodegenApi.CodegenTableVO) => {
    previewRef.value.open(row.id)
}

/** 删除按钮操作 */
const handleDelete = async (id: number) => {
    try {
        // 删除的二次确认
        await message.delConfirm()
        // 发起删除
        await CodegenApi.deleteCodegenTable(id)
        message.success(t('common.delSuccess'))
        // 刷新列表
        await getList()
    } catch {
    }
}

/** 同步操作  */
const handleSyncDB = async (row: CodegenApi.CodegenTableVO) => {
    // 基于 DB 同步
    const tableName = row.tableName
    try {
        await message.confirm('确认要强制同步' + tableName + '表结构吗?', t('common.reminder'))
        await CodegenApi.syncCodegenFromDB(row.id)
        message.success('同步成功')
    } catch {
    }
}

/** 生成代码操作 */
const handleGenTable = async (row: CodegenApi.CodegenTableVO) => {
    const res = await CodegenApi.downloadCodegen(row.id)
    download.zip(res, 'codegen-' + row.className + '.zip')
}

/** 初始化 **/
onMounted(async () => {
    await getList()
    // 加载数据源列表
    dataSourceConfigList.value = await DataSourceConfigApi.getDataSourceConfigList()
})
</script>
